Pandas Profiling Report

Dataset statistics

Number of variables	36
Number of observations	180519
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	49.6 MiB
Average record size in memory	288.0 B

Variable types

Categorical	22
Numeric	14

Alerts

`product_status` has constant value ""	Constant
`customer_city` has a high cardinality: 563 distinct values	High cardinality
`order_city` has a high cardinality: 3597 distinct values	High cardinality
`order_country` has a high cardinality: 164 distinct values	High cardinality
`order_date` has a high cardinality: 65752 distinct values	High cardinality
`order_state` has a high cardinality: 1089 distinct values	High cardinality
`product_name` has a high cardinality: 118 distinct values	High cardinality
`shipping_date` has a high cardinality: 63701 distinct values	High cardinality
`shipping_days_real` is highly overall correlated with `shipping_days_scheduled` and 3 other fields	High correlation
`profit_per_order` is highly overall correlated with `order_item_profit_ratio`	High correlation
`sales_per_customer` is highly overall correlated with `sales` and 1 other fields	High correlation
`category_id` is highly overall correlated with `department_id` and 3 other fields	High correlation
`customer_id` is highly overall correlated with `category_name`	High correlation
`department_id` is highly overall correlated with `category_id` and 3 other fields	High correlation
`order_id` is highly overall correlated with `order_item_id` and 2 other fields	High correlation
`order_item_discount` is highly overall correlated with `order_item_discount_rate` and 1 other fields	High correlation
`order_item_discount_rate` is highly overall correlated with `order_item_discount`	High correlation
`order_item_id` is highly overall correlated with `order_id` and 2 other fields	High correlation
`order_item_profit_ratio` is highly overall correlated with `profit_per_order`	High correlation
`sales` is highly overall correlated with `sales_per_customer` and 3 other fields	High correlation
`product_id_card` is highly overall correlated with `category_id` and 3 other fields	High correlation
`product_price` is highly overall correlated with `sales_per_customer` and 2 other fields	High correlation
`type` is highly overall correlated with `order_status`	High correlation
`shipping_days_scheduled` is highly overall correlated with `shipping_days_real` and 1 other fields	High correlation
`delivery_status` is highly overall correlated with `shipping_days_real` and 2 other fields	High correlation
`late_delivery_risk` is highly overall correlated with `shipping_days_real` and 1 other fields	High correlation
`category_name` is highly overall correlated with `category_id` and 6 other fields	High correlation
`customer_country` is highly overall correlated with `customer_state`	High correlation
`customer_state` is highly overall correlated with `customer_country`	High correlation
`department_name` is highly overall correlated with `category_id` and 3 other fields	High correlation
`market` is highly overall correlated with `order_id` and 2 other fields	High correlation
`order_region` is highly overall correlated with `order_id` and 2 other fields	High correlation
`order_status` is highly overall correlated with `type` and 1 other fields	High correlation
`shipping_mode` is highly overall correlated with `shipping_days_real` and 1 other fields	High correlation
`order_date` is uniformly distributed	Uniform
`order_item_id` is uniformly distributed	Uniform
`shipping_date` is uniformly distributed	Uniform
`order_item_id` has unique values	Unique
`shipping_days_real` has 5080 (2.8%) zeros	Zeros
`order_item_discount` has 10028 (5.6%) zeros	Zeros
`order_item_discount_rate` has 10028 (5.6%) zeros	Zeros

Reproduction

Analysis started	2023-04-30 10:29:27.261934
Analysis finished	2023-04-30 10:30:18.325188
Duration	51.06 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

DEBIT	69295
TRANSFER	49883
PAYMENT	41725
CASH	19616

Length

Max length	8
Median length	7
Mean length	6.1826068
Min length	4

Characters and Unicode

Total characters	1116078
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DEBIT
2nd row	TRANSFER
3rd row	CASH
4th row	DEBIT
5th row	PAYMENT

Common Values

Value	Count	Frequency (%)
DEBIT	69295	38.4%
TRANSFER	49883	27.6%
PAYMENT	41725	23.1%
CASH	19616	10.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
debit	69295	38.4%
transfer	49883	27.6%
payment	41725	23.1%
cash	19616	10.9%

Most occurring characters

Value	Count	Frequency (%)
E	160903	14.4%
T	160903	14.4%
A	111224	10.0%
R	99766	8.9%
N	91608	8.2%
S	69499	6.2%
D	69295	6.2%
B	69295	6.2%
I	69295	6.2%
F	49883	4.5%
Other values (5)	164407	14.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1116078	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	160903	14.4%
T	160903	14.4%
A	111224	10.0%
R	99766	8.9%
N	91608	8.2%
S	69499	6.2%
D	69295	6.2%
B	69295	6.2%
I	69295	6.2%
F	49883	4.5%
Other values (5)	164407	14.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1116078	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	160903	14.4%
T	160903	14.4%
A	111224	10.0%
R	99766	8.9%
N	91608	8.2%
S	69499	6.2%
D	69295	6.2%
B	69295	6.2%
I	69295	6.2%
F	49883	4.5%
Other values (5)	164407	14.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1116078	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	160903	14.4%
T	160903	14.4%
A	111224	10.0%
R	99766	8.9%
N	91608	8.2%
S	69499	6.2%
D	69295	6.2%
B	69295	6.2%
I	69295	6.2%
F	49883	4.5%
Other values (5)	164407	14.7%

shipping_days_real
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.497654

Minimum	0
Maximum	6
Zeros	5080
Zeros (%)	2.8%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.6237218
Coefficient of variation (CV)	0.46423169
Kurtosis	-1.0079136
Mean	3.497654
Median Absolute Deviation (MAD)	1
Skewness	0.084771273
Sum	631393
Variance	2.6364726
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	56618	31.4%
3	28765	15.9%
6	28723	15.9%
4	28513	15.8%
5	28163	15.6%
0	5080	2.8%
1	4657	2.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5080	2.8%
1	4657	2.6%
2	56618	31.4%
3	28765	15.9%
4	28513	15.8%
5	28163	15.6%
6	28723	15.9%

Value	Count	Frequency (%)
6	28723	15.9%
5	28163	15.6%
4	28513	15.8%
3	28765	15.9%
2	56618	31.4%
1	4657	2.6%
0	5080	2.8%

shipping_days_scheduled
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

4	107752
2	35216
1	27814
0	9737

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	180519
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	4
4th row	4
5th row	4

Common Values

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Most occurring characters

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	180519	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	180519	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	180519	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

profit_per_order
Real number (ℝ)

Distinct	21998
Distinct (%)	12.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.974989

Minimum	-4274.98
Maximum	911.79999
Zeros	1177
Zeros (%)	0.7%
Negative	33784
Negative (%)	18.7%
Memory size	1.4 MiB

Quantile statistics

Minimum	-4274.98
5-th percentile	-139.251
Q1	7
median	31.52
Q3	64.800003
95-th percentile	132.28999
Maximum	911.79999
Range	5186.78
Interquartile range (IQR)	57.800003

Descriptive statistics

Standard deviation	104.43353
Coefficient of variation (CV)	4.7523813
Kurtosis	71.377259
Mean	21.974989
Median Absolute Deviation (MAD)	27.88
Skewness	-4.7418341
Sum	3966903
Variance	10906.361
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1177	0.7%
143.9900055	199	0.1%
72	194	0.1%
46.79999924	188	0.1%
24	181	0.1%
18	175	0.1%
63.70000076	172	0.1%
62.40000153	168	0.1%
12	166	0.1%
14.39999962	166	0.1%
Other values (21988)	177733	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-4274.97998	1	< 0.1%
-3442.5	1	< 0.1%
-3366	1	< 0.1%
-3000	1	< 0.1%
-2592	1	< 0.1%
-2550	1	< 0.1%
-2351.25	1	< 0.1%
-2328	1	< 0.1%
-2280	1	< 0.1%
-2255.25	1	< 0.1%

Value	Count	Frequency (%)
911.7999878	1	< 0.1%
864	1	< 0.1%
721.5999756	1	< 0.1%
720.2999878	1	< 0.1%
720	2	< 0.1%
712.9500122	1	< 0.1%
708.75	1	< 0.1%
705.5999756	2	< 0.1%
705	1	< 0.1%
698.4000244	2	< 0.1%

sales_per_customer
Real number (ℝ)

Distinct	2927
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	183.10761

Minimum	7.4899998
Maximum	1939.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	7.4899998
5-th percentile	41.5
Q1	104.38
median	163.99001
Q3	247.39999
95-th percentile	383.98001
Maximum	1939.99
Range	1932.5
Interquartile range (IQR)	143.02

Descriptive statistics

Standard deviation	120.04367
Coefficient of variation (CV)	0.65559084
Kurtosis	23.920362
Mean	183.10761
Median Absolute Deviation (MAD)	67.000008
Skewness	2.8884461
Sum	33054402
Variance	14410.483
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
122.8399963	1264	0.7%
109.1900024	1247	0.7%
124.7900009	1243	0.7%
129.9900055	1243	0.7%
116.9899979	1243	0.7%
123.4899979	1243	0.7%
120.8899994	1243	0.7%
127.3899994	1243	0.7%
97.48999786	1243	0.7%
118.2900009	1243	0.7%
Other values (2917)	168064	93.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.489999771	3	< 0.1%
7.989999771	3	< 0.1%
8.18999958	3	< 0.1%
8.289999962	3	< 0.1%
8.390000343	3	< 0.1%
8.470000267	15	< 0.1%
8.489999771	3	< 0.1%
8.659999847	29	< 0.1%
8.68999958	3	< 0.1%
8.789999962	3	< 0.1%

Value	Count	Frequency (%)
1939.98999	1	< 0.1%
1919.98999	1	< 0.1%
1899.98999	1	< 0.1%
1889.98999	1	< 0.1%
1859.98999	1	< 0.1%
1819.98999	1	< 0.1%
1799.98999	1	< 0.1%
1759.98999	1	< 0.1%
1739.98999	1	< 0.1%
1699.98999	1	< 0.1%

delivery_status
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Late delivery	98977
Advance shipping	41592
Shipping on time	32196
Shipping canceled	7754

Length

Max length	17
Median length	13
Mean length	14.39808
Min length	13

Characters and Unicode

Total characters	2599127
Distinct characters	21
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Advance shipping
2nd row	Late delivery
3rd row	Shipping on time
4th row	Advance shipping
5th row	Advance shipping

Common Values

Value	Count	Frequency (%)
Late delivery	98977	54.8%
Advance shipping	41592	23.0%
Shipping on time	32196	17.8%
Shipping canceled	7754	4.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
late	98977	25.2%
delivery	98977	25.2%
shipping	81542	20.7%
advance	41592	10.6%
on	32196	8.2%
time	32196	8.2%
canceled	7754	2.0%

Most occurring characters

Value	Count	Frequency (%)
e	386227	14.9%
i	294257	11.3%
	212715	8.2%
n	163084	6.3%
p	163084	6.3%
d	148323	5.7%
a	148323	5.7%
v	140569	5.4%
t	131173	5.0%
l	106731	4.1%
Other values (11)	704641	27.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2205893	84.9%
Space Separator	212715	8.2%
Uppercase Letter	180519	6.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	386227	17.5%
i	294257	13.3%
n	163084	7.4%
p	163084	7.4%
d	148323	6.7%
a	148323	6.7%
v	140569	6.4%
t	131173	5.9%
l	106731	4.8%
y	98977	4.5%
Other values (7)	425145	19.3%

Uppercase Letter

Value	Count	Frequency (%)
L	98977	54.8%
A	41592	23.0%
S	39950	22.1%

Space Separator

Value	Count	Frequency (%)
	212715	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2386412	91.8%
Common	212715	8.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	386227	16.2%
i	294257	12.3%
n	163084	6.8%
p	163084	6.8%
d	148323	6.2%
a	148323	6.2%
v	140569	5.9%
t	131173	5.5%
l	106731	4.5%
L	98977	4.1%
Other values (10)	605664	25.4%

Common

Value	Count	Frequency (%)
	212715	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2599127	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	386227	14.9%
i	294257	11.3%
	212715	8.2%
n	163084	6.3%
p	163084	6.3%
d	148323	5.7%
a	148323	5.7%
v	140569	5.4%
t	131173	5.0%
l	106731	4.1%
Other values (11)	704641	27.1%

late_delivery_risk
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

1	98977
0	81542

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	180519
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Most occurring characters

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	180519	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	180519	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	180519	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

category_id
Real number (ℝ)

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.851451

Minimum	2
Maximum	76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	2
5-th percentile	9
Q1	18
median	29
Q3	45
95-th percentile	48
Maximum	76
Range	74
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	15.640064
Coefficient of variation (CV)	0.49103145
Kurtosis	-0.60326101
Mean	31.851451
Median Absolute Deviation (MAD)	14
Skewness	0.3616248
Sum	5749792
Variance	244.6116
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17	24551	13.6%
18	22246	12.3%
24	21035	11.7%
46	19298	10.7%
45	17325	9.6%
48	15540	8.6%
43	13729	7.6%
9	12487	6.9%
29	10984	6.1%
37	2029	1.1%
Other values (41)	21295	11.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	138	0.1%
3	632	0.4%
4	67	< 0.1%
5	343	0.2%
6	328	0.2%
7	614	0.3%
9	12487	6.9%
10	111	0.1%
11	309	0.2%
12	423	0.2%

Value	Count	Frequency (%)
76	650	0.4%
75	838	0.5%
74	529	0.3%
73	357	0.2%
72	492	0.3%
71	434	0.2%
70	208	0.1%
69	362	0.2%
68	484	0.3%
67	483	0.3%

category_name
Categorical

Distinct	50
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Cleats	24551
Men's Footwear	22246
Women's Apparel	21035
Indoor/Outdoor Games	19298
Fishing	17325
Other values (45)	76064

Length

Max length	20
Median length	17
Mean length	12.707793
Min length	4

Characters and Unicode

Total characters	2293998
Distinct characters	49
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Sporting Goods
2nd row	Sporting Goods
3rd row	Sporting Goods
4th row	Sporting Goods
5th row	Sporting Goods

Common Values

Value	Count	Frequency (%)
Cleats	24551	13.6%
Men's Footwear	22246	12.3%
Women's Apparel	21035	11.7%
Indoor/Outdoor Games	19298	10.7%
Fishing	17325	9.6%
Water Sports	15540	8.6%
Camping & Hiking	13729	7.6%
Cardio Equipment	12487	6.9%
Shop By Sport	10984	6.1%
Electronics	3156	1.7%
Other values (40)	20168	11.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
cleats	24551	7.3%
men's	22737	6.8%
apparel	22677	6.8%
footwear	22246	6.6%
women's	21866	6.5%
games	20136	6.0%
indoor/outdoor	19298	5.7%
fishing	17325	5.2%
	15613	4.7%
water	15540	4.6%
Other values (60)	133774	39.8%

Most occurring characters

Value	Count	Frequency (%)
o	213963	9.3%
e	180726	7.9%
	156787	6.8%
r	150127	6.5%
s	145604	6.3%
a	140194	6.1%
n	132705	5.8%
t	130741	5.7%
i	114517	5.0%
p	110861	4.8%
Other values (39)	817773	35.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1712275	74.6%
Uppercase Letter	342143	14.9%
Space Separator	156787	6.8%
Other Punctuation	81819	3.6%
Dash Punctuation	974	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	213963	12.5%
e	180726	10.6%
r	150127	8.8%
s	145604	8.5%
a	140194	8.2%
n	132705	7.8%
t	130741	7.6%
i	114517	6.7%
p	110861	6.5%
m	69683	4.1%
Other values (14)	323154	18.9%

Uppercase Letter

Value	Count	Frequency (%)
C	56058	16.4%
S	40270	11.8%
F	39880	11.7%
W	37406	10.9%
G	27667	8.1%
A	25257	7.4%
M	24017	7.0%
I	20272	5.9%
O	19298	5.6%
E	16074	4.7%
Other values (9)	35944	10.5%

Other Punctuation

Value	Count	Frequency (%)
'	46840	57.2%
/	19298	23.6%
&	15613	19.1%
!	68	0.1%

Space Separator

Value	Count	Frequency (%)
	156787	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	974	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2054418	89.6%
Common	239580	10.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	213963	10.4%
e	180726	8.8%
r	150127	7.3%
s	145604	7.1%
a	140194	6.8%
n	132705	6.5%
t	130741	6.4%
i	114517	5.6%
p	110861	5.4%
m	69683	3.4%
Other values (33)	665297	32.4%

Common

Value	Count	Frequency (%)
	156787	65.4%
'	46840	19.6%
/	19298	8.1%
&	15613	6.5%
-	974	0.4%
!	68	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2293998	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	213963	9.3%
e	180726	7.9%
	156787	6.8%
r	150127	6.5%
s	145604	6.3%
a	140194	6.1%
n	132705	5.8%
t	130741	5.7%
i	114517	5.0%
p	110861	4.8%
Other values (39)	817773	35.6%

customer_city
Categorical

Distinct	563
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Caguas	66770
Chicago	3885
Los Angeles	3417
Brooklyn	3412
New York	1816
Other values (558)	101219

Length

Max length	20
Median length	19
Mean length	7.7086235
Min length	2

Characters and Unicode

Total characters	1391553
Distinct characters	52
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Caguas
2nd row	Caguas
3rd row	San Jose
4th row	Los Angeles
5th row	Caguas

Common Values

Value	Count	Frequency (%)
Caguas	66770	37.0%
Chicago	3885	2.2%
Los Angeles	3417	1.9%
Brooklyn	3412	1.9%
New York	1816	1.0%
Philadelphia	1577	0.9%
Bronx	1500	0.8%
San Diego	1437	0.8%
Miami	1314	0.7%
Houston	1297	0.7%
Other values (553)	94094	52.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
caguas	66770	30.8%
san	5129	2.4%
chicago	3937	1.8%
los	3417	1.6%
angeles	3417	1.6%
brooklyn	3412	1.6%
new	3107	1.4%
york	2165	1.0%
beach	2084	1.0%
city	1659	0.8%
Other values (585)	121822	56.2%

Most occurring characters

Value	Count	Frequency (%)
a	228937	16.5%
s	111699	8.0%
u	89280	6.4%
g	89233	6.4%
o	85515	6.1%
C	82588	5.9%
e	81172	5.8%
n	76231	5.5%
l	60937	4.4%
i	60636	4.4%
Other values (42)	425325	30.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1138231	81.8%
Uppercase Letter	216922	15.6%
Space Separator	36400	2.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	228937	20.1%
s	111699	9.8%
u	89280	7.8%
g	89233	7.8%
o	85515	7.5%
e	81172	7.1%
n	76231	6.7%
l	60937	5.4%
i	60636	5.3%
r	57370	5.0%
Other values (16)	197221	17.3%

Uppercase Letter

Value	Count	Frequency (%)
C	82588	38.1%
S	14019	6.5%
B	13944	6.4%
L	13048	6.0%
A	10848	5.0%
P	10565	4.9%
M	9378	4.3%
H	8518	3.9%
D	5758	2.7%
N	5664	2.6%
Other values (15)	42592	19.6%

Space Separator

Value	Count	Frequency (%)
	36400	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1355153	97.4%
Common	36400	2.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	228937	16.9%
s	111699	8.2%
u	89280	6.6%
g	89233	6.6%
o	85515	6.3%
C	82588	6.1%
e	81172	6.0%
n	76231	5.6%
l	60937	4.5%
i	60636	4.5%
Other values (41)	388925	28.7%

Common

Value	Count	Frequency (%)
	36400	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1391553	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	228937	16.5%
s	111699	8.0%
u	89280	6.4%
g	89233	6.4%
o	85515	6.1%
C	82588	5.9%
e	81172	5.8%
n	76231	5.5%
l	60937	4.4%
i	60636	4.4%
Other values (42)	425325	30.6%

customer_country
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

EE. UU.	111146
Puerto Rico	69373

Length

Max length	11
Median length	7
Mean length	8.53719
Min length	7

Characters and Unicode

Total characters	1541125
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Puerto Rico
2nd row	Puerto Rico
3rd row	EE. UU.
4th row	EE. UU.
5th row	Puerto Rico

Common Values

Value	Count	Frequency (%)
EE. UU.	111146	61.6%
Puerto Rico	69373	38.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ee	111146	30.8%
uu	111146	30.8%
puerto	69373	19.2%
rico	69373	19.2%

Most occurring characters

Value	Count	Frequency (%)
E	222292	14.4%
.	222292	14.4%
U	222292	14.4%
	180519	11.7%
o	138746	9.0%
P	69373	4.5%
u	69373	4.5%
e	69373	4.5%
r	69373	4.5%
t	69373	4.5%
Other values (3)	208119	13.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	583330	37.9%
Lowercase Letter	554984	36.0%
Other Punctuation	222292	14.4%
Space Separator	180519	11.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	138746	25.0%
u	69373	12.5%
e	69373	12.5%
r	69373	12.5%
t	69373	12.5%
i	69373	12.5%
c	69373	12.5%

Uppercase Letter

Value	Count	Frequency (%)
E	222292	38.1%
U	222292	38.1%
P	69373	11.9%
R	69373	11.9%

Other Punctuation

Value	Count	Frequency (%)
.	222292	100.0%

Space Separator

Value	Count	Frequency (%)
	180519	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1138314	73.9%
Common	402811	26.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	222292	19.5%
U	222292	19.5%
o	138746	12.2%
P	69373	6.1%
u	69373	6.1%
e	69373	6.1%
r	69373	6.1%
t	69373	6.1%
R	69373	6.1%
i	69373	6.1%

Common

Value	Count	Frequency (%)
.	222292	55.2%
	180519	44.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1541125	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	222292	14.4%
.	222292	14.4%
U	222292	14.4%
	180519	11.7%
o	138746	9.0%
P	69373	4.5%
u	69373	4.5%
e	69373	4.5%
r	69373	4.5%
t	69373	4.5%
Other values (3)	208119	13.5%

customer_id
Real number (ℝ)

Distinct	20652
Distinct (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6691.3795

Minimum	1
Maximum	20757
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1
5-th percentile	649
Q1	3258.5
median	6457
Q3	9779
95-th percentile	12383
Maximum	20757
Range	20756
Interquartile range (IQR)	6520.5

Descriptive statistics

Standard deviation	4162.9181
Coefficient of variation (CV)	0.62213152
Kurtosis	0.014898822
Mean	6691.3795
Median Absolute Deviation (MAD)	3263
Skewness	0.48876825
Sum	1.2079211 × 10⁹
Variance	17329887
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5654	47	< 0.1%
10591	45	< 0.1%
5004	45	< 0.1%
5715	44	< 0.1%
3708	44	< 0.1%
9371	44	< 0.1%
1443	43	< 0.1%
791	43	< 0.1%
12284	43	< 0.1%
2641	43	< 0.1%
Other values (20642)	180078	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	10	< 0.1%
3	18	< 0.1%
4	14	< 0.1%
5	7	< 0.1%
6	15	< 0.1%
7	22	< 0.1%
8	19	< 0.1%
9	14	< 0.1%
10	8	< 0.1%

Value	Count	Frequency (%)
20757	1	< 0.1%
20756	1	< 0.1%
20755	1	< 0.1%
20754	1	< 0.1%
20753	1	< 0.1%
20752	1	< 0.1%
20751	1	< 0.1%
20750	1	< 0.1%
20749	1	< 0.1%
20748	1	< 0.1%

customer_segment
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Consumer	93504
Corporate	54789
Home Office	32226

Length

Max length	11
Median length	8
Mean length	8.839064
Min length	8

Characters and Unicode

Total characters	1595619
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Consumer
2nd row	Consumer
3rd row	Consumer
4th row	Home Office
5th row	Corporate

Common Values

Value	Count	Frequency (%)
Consumer	93504	51.8%
Corporate	54789	30.4%
Home Office	32226	17.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
consumer	93504	44.0%
corporate	54789	25.8%
home	32226	15.1%
office	32226	15.1%

Most occurring characters

Value	Count	Frequency (%)
o	235308	14.7%
e	212745	13.3%
r	203082	12.7%
C	148293	9.3%
m	125730	7.9%
n	93504	5.9%
s	93504	5.9%
u	93504	5.9%
f	64452	4.0%
t	54789	3.4%
Other values (7)	270708	17.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1350648	84.6%
Uppercase Letter	212745	13.3%
Space Separator	32226	2.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	235308	17.4%
e	212745	15.8%
r	203082	15.0%
m	125730	9.3%
n	93504	6.9%
s	93504	6.9%
u	93504	6.9%
f	64452	4.8%
t	54789	4.1%
p	54789	4.1%
Other values (3)	119241	8.8%

Uppercase Letter

Value	Count	Frequency (%)
C	148293	69.7%
H	32226	15.1%
O	32226	15.1%

Space Separator

Value	Count	Frequency (%)
	32226	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1563393	98.0%
Common	32226	2.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	235308	15.1%
e	212745	13.6%
r	203082	13.0%
C	148293	9.5%
m	125730	8.0%
n	93504	6.0%
s	93504	6.0%
u	93504	6.0%
f	64452	4.1%
t	54789	3.5%
Other values (6)	238482	15.3%

Common

Value	Count	Frequency (%)
	32226	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1595619	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	235308	14.7%
e	212745	13.3%
r	203082	12.7%
C	148293	9.3%
m	125730	7.9%
n	93504	5.9%
s	93504	5.9%
u	93504	5.9%
f	64452	4.0%
t	54789	3.4%
Other values (7)	270708	17.0%

customer_state
Categorical

Distinct	46
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

PR	69373
CA	29223
NY	11327
TX	9103
IL	7631
Other values (41)	53862

Length

Max length	5
Median length	2
Mean length	2.0000499
Min length	2

Characters and Unicode

Total characters	361047
Distinct characters	31
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	PR
2nd row	PR
3rd row	CA
4th row	CA
5th row	PR

Common Values

Value	Count	Frequency (%)
PR	69373	38.4%
CA	29223	16.2%
NY	11327	6.3%
TX	9103	5.0%
IL	7631	4.2%
FL	5456	3.0%
OH	4095	2.3%
PA	3824	2.1%
MI	3804	2.1%
NJ	3191	1.8%
Other values (36)	33492	18.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pr	69373	38.4%
ca	29223	16.2%
ny	11327	6.3%
tx	9103	5.0%
il	7631	4.2%
fl	5456	3.0%
oh	4095	2.3%
pa	3824	2.1%
mi	3804	2.1%
nj	3191	1.8%
Other values (36)	33492	18.6%

Most occurring characters

Value	Count	Frequency (%)
P	73197	20.3%
R	71448	19.8%
A	44166	12.2%
C	35467	9.8%
N	21949	6.1%
I	14591	4.0%
L	14070	3.9%
T	12834	3.6%
Y	11814	3.3%
M	10888	3.0%
Other values (21)	50623	14.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	361032	> 99.9%
Decimal Number	15	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	73197	20.3%
R	71448	19.8%
A	44166	12.2%
C	35467	9.8%
N	21949	6.1%
I	14591	4.0%
L	14070	3.9%
T	12834	3.6%
Y	11814	3.3%
M	10888	3.0%
Other values (14)	50608	14.0%

Decimal Number

Value	Count	Frequency (%)
5	4	26.7%
9	3	20.0%
7	3	20.0%
8	2	13.3%
1	1	6.7%
3	1	6.7%
2	1	6.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	361032	> 99.9%
Common	15	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	73197	20.3%
R	71448	19.8%
A	44166	12.2%
C	35467	9.8%
N	21949	6.1%
I	14591	4.0%
L	14070	3.9%
T	12834	3.6%
Y	11814	3.3%
M	10888	3.0%
Other values (14)	50608	14.0%

Common

Value	Count	Frequency (%)
5	4	26.7%
9	3	20.0%
7	3	20.0%
8	2	13.3%
1	1	6.7%
3	1	6.7%
2	1	6.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	361047	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	73197	20.3%
R	71448	19.8%
A	44166	12.2%
C	35467	9.8%
N	21949	6.1%
I	14591	4.0%
L	14070	3.9%
T	12834	3.6%
Y	11814	3.3%
M	10888	3.0%
Other values (21)	50623	14.0%

department_id
Real number (ℝ)

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.4434602

Minimum	2
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	4
median	5
Q3	7
95-th percentile	7
Maximum	12
Range	10
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.629246
Coefficient of variation (CV)	0.29930338
Kurtosis	-0.18169651
Mean	5.4434602
Median Absolute Deviation (MAD)	1
Skewness	0.27332063
Sum	982648
Variance	2.6544426
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
7	66861	37.0%
4	48998	27.1%
5	33220	18.4%
3	14525	8.0%
6	9686	5.4%
2	2479	1.4%
9	2026	1.1%
10	1465	0.8%
11	492	0.3%
8	405	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	2479	1.4%
3	14525	8.0%
4	48998	27.1%
5	33220	18.4%
6	9686	5.4%
7	66861	37.0%
8	405	0.2%
9	2026	1.1%
10	1465	0.8%
11	492	0.3%

Value	Count	Frequency (%)
12	362	0.2%
11	492	0.3%
10	1465	0.8%
9	2026	1.1%
8	405	0.2%
7	66861	37.0%
6	9686	5.4%
5	33220	18.4%
4	48998	27.1%
3	14525	8.0%

department_name
Categorical

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Fan Shop	66861
Apparel	48998
Golf	33220
Footwear	14525
Outdoors	9686
Other values (6)	7229

Length

Max length	18
Median length	8
Mean length	7.0397133
Min length	4

Characters and Unicode

Total characters	1270802
Distinct characters	30
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fitness
2nd row	Fitness
3rd row	Fitness
4th row	Fitness
5th row	Fitness

Common Values

Value	Count	Frequency (%)
Fan Shop	66861	37.0%
Apparel	48998	27.1%
Golf	33220	18.4%
Footwear	14525	8.0%
Outdoors	9686	5.4%
Fitness	2479	1.4%
Discs Shop	2026	1.1%
Technology	1465	0.8%
Pet Shop	492	0.3%
Book Shop	405	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
shop	69784	27.8%
fan	66861	26.6%
apparel	48998	19.5%
golf	33220	13.2%
footwear	14525	5.8%
outdoors	9686	3.9%
fitness	2479	1.0%
discs	2026	0.8%
technology	1465	0.6%
pet	492	0.2%
Other values (4)	1491	0.6%

Most occurring characters

Value	Count	Frequency (%)
p	167780	13.2%
o	155166	12.2%
a	131470	10.3%
l	84045	6.6%
F	83865	6.6%
r	73209	5.8%
h	71611	5.6%
n	71167	5.6%
	70870	5.6%
S	69784	5.5%
Other values (20)	291835	23.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	949267	74.7%
Uppercase Letter	250665	19.7%
Space Separator	70870	5.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
p	167780	17.7%
o	155166	16.3%
a	131470	13.8%
l	84045	8.9%
r	73209	7.7%
h	71611	7.5%
n	71167	7.5%
e	68683	7.2%
f	33220	3.5%
t	27906	2.9%
Other values (9)	65010	6.8%

Uppercase Letter

Value	Count	Frequency (%)
F	83865	33.5%
S	69784	27.8%
A	48998	19.5%
G	33220	13.3%
O	9686	3.9%
D	2026	0.8%
T	1465	0.6%
B	767	0.3%
P	492	0.2%
H	362	0.1%

Space Separator

Value	Count	Frequency (%)
	70870	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1199932	94.4%
Common	70870	5.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
p	167780	14.0%
o	155166	12.9%
a	131470	11.0%
l	84045	7.0%
F	83865	7.0%
r	73209	6.1%
h	71611	6.0%
n	71167	5.9%
S	69784	5.8%
e	68683	5.7%
Other values (19)	223152	18.6%

Common

Value	Count	Frequency (%)
	70870	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1270802	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
p	167780	13.2%
o	155166	12.2%
a	131470	10.3%
l	84045	6.6%
F	83865	6.6%
r	73209	5.8%
h	71611	5.6%
n	71167	5.6%
	70870	5.6%
S	69784	5.5%
Other values (20)	291835	23.0%

market
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

LATAM	51594
Europe	50252
Pacific Asia	41260
USCA	25799
Africa	11614

Length

Max length	12
Median length	6
Mean length	6.7997385
Min length	4

Characters and Unicode

Total characters	1227482
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Pacific Asia
2nd row	Pacific Asia
3rd row	Pacific Asia
4th row	Pacific Asia
5th row	Pacific Asia

Common Values

Value	Count	Frequency (%)
LATAM	51594	28.6%
Europe	50252	27.8%
Pacific Asia	41260	22.9%
USCA	25799	14.3%
Africa	11614	6.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
latam	51594	23.3%
europe	50252	22.7%
pacific	41260	18.6%
asia	41260	18.6%
usca	25799	11.6%
africa	11614	5.2%

Most occurring characters

Value	Count	Frequency (%)
A	181861	14.8%
i	135394	11.0%
a	94134	7.7%
c	94134	7.7%
r	61866	5.0%
f	52874	4.3%
L	51594	4.2%
T	51594	4.2%
M	51594	4.2%
E	50252	4.1%
Other values (10)	402185	32.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	680670	55.5%
Uppercase Letter	505552	41.2%
Space Separator	41260	3.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	135394	19.9%
a	94134	13.8%
c	94134	13.8%
r	61866	9.1%
f	52874	7.8%
u	50252	7.4%
o	50252	7.4%
p	50252	7.4%
e	50252	7.4%
s	41260	6.1%

Uppercase Letter

Value	Count	Frequency (%)
A	181861	36.0%
L	51594	10.2%
T	51594	10.2%
M	51594	10.2%
E	50252	9.9%
P	41260	8.2%
U	25799	5.1%
S	25799	5.1%
C	25799	5.1%

Space Separator

Value	Count	Frequency (%)
	41260	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1186222	96.6%
Common	41260	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	181861	15.3%
i	135394	11.4%
a	94134	7.9%
c	94134	7.9%
r	61866	5.2%
f	52874	4.5%
L	51594	4.3%
T	51594	4.3%
M	51594	4.3%
E	50252	4.2%
Other values (9)	360925	30.4%

Common

Value	Count	Frequency (%)
	41260	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1227482	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	181861	14.8%
i	135394	11.0%
a	94134	7.7%
c	94134	7.7%
r	61866	5.0%
f	52874	4.3%
L	51594	4.2%
T	51594	4.2%
M	51594	4.2%
E	50252	4.1%
Other values (10)	402185	32.8%

order_city
Categorical

Distinct	3597
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Santo Domingo	2211
New York City	2202
Los Angeles	1845
Tegucigalpa	1783
Managua	1682
Other values (3592)	170796

Length

Max length	35
Median length	29
Mean length	8.5542131
Min length	2

Characters and Unicode

Total characters	1544198
Distinct characters	79
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	69 ?
Unique (%)	< 0.1%

Sample

1st row	Bekasi
2nd row	Bikaner
3rd row	Bikaner
4th row	Townsville
5th row	Townsville

Common Values

Value	Count	Frequency (%)
Santo Domingo	2211	1.2%
New York City	2202	1.2%
Los Angeles	1845	1.0%
Tegucigalpa	1783	1.0%
Managua	1682	0.9%
Mexico City	1484	0.8%
Manila	1381	0.8%
Philadelphia	1302	0.7%
San Francisco	1297	0.7%
London	1187	0.7%
Other values (3587)	164145	90.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
san	6508	2.9%
city	5626	2.5%
de	3211	1.4%
los	2435	1.1%
santo	2339	1.0%
new	2316	1.0%
york	2316	1.0%
domingo	2239	1.0%
angeles	1857	0.8%
tegucigalpa	1783	0.8%
Other values (3768)	197270	86.6%

Most occurring characters

Value	Count	Frequency (%)
a	197677	12.8%
e	116504	7.5%
n	115087	7.5%
o	111297	7.2%
i	94427	6.1%
r	85703	5.6%
l	76707	5.0%
u	57916	3.8%
t	56384	3.7%
s	56123	3.6%
Other values (69)	576373	37.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1264434	81.9%
Uppercase Letter	225693	14.6%
Space Separator	47381	3.1%
Dash Punctuation	5982	0.4%
Other Punctuation	659	< 0.1%
Open Punctuation	21	< 0.1%
Close Punctuation	21	< 0.1%
Control	7	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	197677	15.6%
e	116504	9.2%
n	115087	9.1%
o	111297	8.8%
i	94427	7.5%
r	85703	6.8%
l	76707	6.1%
u	57916	4.6%
t	56384	4.5%
s	56123	4.4%
Other values (32)	296609	23.5%

Uppercase Letter

Value	Count	Frequency (%)
S	28079	12.4%
C	25625	11.4%
M	23445	10.4%
B	16591	7.4%
P	15223	6.7%
L	14772	6.5%
A	13507	6.0%
T	10236	4.5%
D	9031	4.0%
N	7965	3.5%
Other values (19)	61219	27.1%

Other Punctuation

Value	Count	Frequency (%)
'	509	77.2%
?	137	20.8%
.	13	2.0%

Space Separator

Value	Count	Frequency (%)
	47381	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5982	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	21	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	21	100.0%

Control

Value	Count	Frequency (%)
	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1490127	96.5%
Common	54071	3.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	197677	13.3%
e	116504	7.8%
n	115087	7.7%
o	111297	7.5%
i	94427	6.3%
r	85703	5.8%
l	76707	5.1%
u	57916	3.9%
t	56384	3.8%
s	56123	3.8%
Other values (61)	522302	35.1%

Common

Value	Count	Frequency (%)
	47381	87.6%
-	5982	11.1%
'	509	0.9%
?	137	0.3%
(	21	< 0.1%
)	21	< 0.1%
.	13	< 0.1%
	7	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1528572	99.0%
None	15626	1.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	197677	12.9%
e	116504	7.6%
n	115087	7.5%
o	111297	7.3%
i	94427	6.2%
r	85703	5.6%
l	76707	5.0%
u	57916	3.8%
t	56384	3.7%
s	56123	3.7%
Other values (49)	560747	36.7%

None

Value	Count	Frequency (%)
í	4201	26.9%
á	4180	26.8%
ó	2167	13.9%
é	1466	9.4%
ã	1354	8.7%
ú	1170	7.5%
ç	279	1.8%
ü	259	1.7%
ñ	166	1.1%
Á	148	0.9%
Other values (10)	236	1.5%

order_country
Categorical

Distinct	164
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Estados Unidos	24840
Francia	13222
México	13172
Alemania	9564
Australia	8497
Other values (159)	111224

Length

Max length	31
Median length	22
Mean length	8.7728272
Min length	4

Characters and Unicode

Total characters	1583662
Distinct characters	61
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Indonesia
2nd row	India
3rd row	India
4th row	Australia
5th row	Australia

Common Values

Value	Count	Frequency (%)
Estados Unidos	24840	13.8%
Francia	13222	7.3%
México	13172	7.3%
Alemania	9564	5.3%
Australia	8497	4.7%
Brasil	7987	4.4%
Reino Unido	7302	4.0%
China	5758	3.2%
Italia	4989	2.8%
India	4783	2.6%
Other values (154)	80405	44.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
unidos	24869	10.8%
estados	24840	10.8%
francia	13222	5.7%
méxico	13172	5.7%
alemania	9564	4.1%
australia	8497	3.7%
brasil	7987	3.5%
reino	7302	3.2%
unido	7302	3.2%
china	5758	2.5%
Other values (175)	108034	46.9%

Most occurring characters

Value	Count	Frequency (%)
a	241810	15.3%
i	166236	10.5%
n	119798	7.6%
s	117962	7.4%
o	109660	6.9%
d	83403	5.3%
r	66669	4.2%
l	62119	3.9%
e	53254	3.4%
t	50532	3.2%
Other values (51)	512219	32.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1303170	82.3%
Uppercase Letter	229618	14.5%
Space Separator	50028	3.2%
Open Punctuation	409	< 0.1%
Close Punctuation	409	< 0.1%
Dash Punctuation	28	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	241810	18.6%
i	166236	12.8%
n	119798	9.2%
s	117962	9.1%
o	109660	8.4%
d	83403	6.4%
r	66669	5.1%
l	62119	4.8%
e	53254	4.1%
t	50532	3.9%
Other values (22)	231727	17.8%

Uppercase Letter

Value	Count	Frequency (%)
E	34032	14.8%
U	33494	14.6%
A	24433	10.6%
I	17168	7.5%
M	16328	7.1%
F	15635	6.8%
C	15397	6.7%
R	13800	6.0%
B	12369	5.4%
S	8781	3.8%
Other values (15)	38181	16.6%

Space Separator

Value	Count	Frequency (%)
	50028	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	409	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	409	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	28	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1532788	96.8%
Common	50874	3.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	241810	15.8%
i	166236	10.8%
n	119798	7.8%
s	117962	7.7%
o	109660	7.2%
d	83403	5.4%
r	66669	4.3%
l	62119	4.1%
e	53254	3.5%
t	50532	3.3%
Other values (47)	461345	30.1%

Common

Value	Count	Frequency (%)
	50028	98.3%
(	409	0.8%
)	409	0.8%
-	28	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1545222	97.6%
None	38440	2.4%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	241810	15.6%
i	166236	10.8%
n	119798	7.8%
s	117962	7.6%
o	109660	7.1%
d	83403	5.4%
r	66669	4.3%
l	62119	4.0%
e	53254	3.4%
t	50532	3.3%
Other values (44)	473779	30.7%

None

Value	Count	Frequency (%)
é	14306	37.2%
í	7138	18.6%
á	6253	16.3%
ú	6043	15.7%
ñ	3868	10.1%
ó	803	2.1%
Á	29	0.1%

order_date
Categorical

HIGH CARDINALITY UNIFORM

Distinct	65752
Distinct (%)	36.4%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

12/14/2016 12:29	5
2/22/2015 14:38	5
2/17/2016 14:08	5
12/31/2016 9:50	5
2/11/2016 16:35	5
Other values (65747)	180494

Length

Max length	16
Median length	15
Mean length	14.498989
Min length	13

Characters and Unicode

Total characters	2617343
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19850 ?
Unique (%)	11.0%

Sample

1st row	1/31/2018 22:56
2nd row	1/13/2018 12:27
3rd row	1/13/2018 12:06
4th row	1/13/2018 11:45
5th row	1/13/2018 11:24

Common Values

Value	Count	Frequency (%)
12/14/2016 12:29	5	< 0.1%
2/22/2015 14:38	5	< 0.1%
2/17/2016 14:08	5	< 0.1%
12/31/2016 9:50	5	< 0.1%
2/11/2016 16:35	5	< 0.1%
12/8/2015 17:54	5	< 0.1%
1/31/2016 2:46	5	< 0.1%
2/9/2016 14:08	5	< 0.1%
11/21/2016 1:29	5	< 0.1%
2/12/2016 11:10	5	< 0.1%
Other values (65742)	180469	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
7/2/2017	220	0.1%
10/27/2015	217	0.1%
7/14/2015	213	0.1%
5/22/2017	213	0.1%
3/18/2016	212	0.1%
11/13/2015	212	0.1%
6/30/2015	211	0.1%
9/18/2016	209	0.1%
5/30/2015	209	0.1%
3/30/2015	207	0.1%
Other values (2557)	358915	99.4%

Most occurring characters

Value	Count	Frequency (%)
1	475462	18.2%
2	385354	14.7%
/	361038	13.8%
0	281809	10.8%
	180519	6.9%
:	180519	6.9%
5	159458	6.1%
6	128237	4.9%
7	120120	4.6%
3	113722	4.3%
Other values (3)	231105	8.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1895267	72.4%
Other Punctuation	541557	20.7%
Space Separator	180519	6.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	475462	25.1%
2	385354	20.3%
0	281809	14.9%
5	159458	8.4%
6	128237	6.8%
7	120120	6.3%
3	113722	6.0%
4	96216	5.1%
8	68825	3.6%
9	66064	3.5%

Other Punctuation

Value	Count	Frequency (%)
/	361038	66.7%
:	180519	33.3%

Space Separator

Value	Count	Frequency (%)
	180519	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2617343	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	475462	18.2%
2	385354	14.7%
/	361038	13.8%
0	281809	10.8%
	180519	6.9%
:	180519	6.9%
5	159458	6.1%
6	128237	4.9%
7	120120	4.6%
3	113722	4.3%
Other values (3)	231105	8.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2617343	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	475462	18.2%
2	385354	14.7%
/	361038	13.8%
0	281809	10.8%
	180519	6.9%
:	180519	6.9%
5	159458	6.1%
6	128237	4.9%
7	120120	4.6%
3	113722	4.3%
Other values (3)	231105	8.8%

order_id
Real number (ℝ)

Distinct	65752
Distinct (%)	36.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36221.895

Minimum	1
Maximum	77204
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1
5-th percentile	3626.8
Q1	18057
median	36140
Q3	54144
95-th percentile	68596
Maximum	77204
Range	77203
Interquartile range (IQR)	36087

Descriptive statistics

Standard deviation	21045.38
Coefficient of variation (CV)	0.58101266
Kurtosis	-1.1529357
Mean	36221.895
Median Absolute Deviation (MAD)	18042
Skewness	0.032708795
Sum	6.5387402 × 10⁹
Variance	4.42908 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48880	5	< 0.1%
3605	5	< 0.1%
28265	5	< 0.1%
50037	5	< 0.1%
27861	5	< 0.1%
23412	5	< 0.1%
27068	5	< 0.1%
27717	5	< 0.1%
47273	5	< 0.1%
27914	5	< 0.1%
Other values (65742)	180469	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	3	< 0.1%
4	4	< 0.1%
5	5	< 0.1%
7	3	< 0.1%
8	4	< 0.1%
9	3	< 0.1%
10	5	< 0.1%
11	5	< 0.1%
12	5	< 0.1%

Value	Count	Frequency (%)
77204	1	< 0.1%
77203	1	< 0.1%
77202	1	< 0.1%
77201	1	< 0.1%
77200	1	< 0.1%
77199	1	< 0.1%
77198	1	< 0.1%
77197	1	< 0.1%
77196	1	< 0.1%
77195	1	< 0.1%

order_item_discount
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1017
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.664741

Minimum	0
Maximum	500
Zeros	10028
Zeros (%)	5.6%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5.4000001
median	14
Q3	29.99
95-th percentile	62.5
Maximum	500
Range	500
Interquartile range (IQR)	24.59

Descriptive statistics

Standard deviation	21.800901
Coefficient of variation (CV)	1.0549806
Kurtosis	25.231267
Mean	20.664741
Median Absolute Deviation (MAD)	10
Skewness	3.0397955
Sum	3730378.4
Variance	475.27928
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10028	5.6%
6	4589	2.5%
12	4067	2.3%
4	3647	2.0%
8	3626	2.0%
10	3424	1.9%
36	3268	1.8%
30	3230	1.8%
20	3123	1.7%
9	2964	1.6%
Other values (1007)	138553	76.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10028	5.6%
0.100000001	3	< 0.1%
0.109999999	15	< 0.1%
0.119999997	29	< 0.1%
0.150000006	7	< 0.1%
0.159999996	7	< 0.1%
0.180000007	3	< 0.1%
0.200000003	16	< 0.1%
0.219999999	6	< 0.1%
0.230000004	44	< 0.1%

Value	Count	Frequency (%)
500	1	< 0.1%
400	1	< 0.1%
375	25	< 0.1%
360	1	< 0.1%
340	1	< 0.1%
320	1	< 0.1%
300	26	< 0.1%
270	25	< 0.1%
260	1	< 0.1%
255	25	< 0.1%

order_item_discount_rate
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.10166819

Minimum	0
Maximum	0.25
Zeros	10028
Zeros (%)	5.6%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.039999999
median	0.1
Q3	0.16
95-th percentile	0.25
Maximum	0.25
Range	0.25
Interquartile range (IQR)	0.12

Descriptive statistics

Standard deviation	0.070415215
Coefficient of variation (CV)	0.69259829
Kurtosis	-0.90115686
Mean	0.10166819
Median Absolute Deviation (MAD)	0.059999995
Skewness	0.3409276
Sum	18353.04
Variance	0.0049583025
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0.039999999	10029	5.6%
0.150000006	10029	5.6%
0.25	10029	5.6%
0.200000003	10029	5.6%
0.180000007	10029	5.6%
0.170000002	10029	5.6%
0.050000001	10029	5.6%
0.159999996	10029	5.6%
0.129999995	10029	5.6%
0.119999997	10029	5.6%
Other values (8)	80229	44.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10028	5.6%
0.01	10028	5.6%
0.02	10028	5.6%
0.029999999	10029	5.6%
0.039999999	10029	5.6%
0.050000001	10029	5.6%
0.059999999	10029	5.6%
0.07	10029	5.6%
0.090000004	10029	5.6%
0.100000001	10029	5.6%

Value	Count	Frequency (%)
0.25	10029	5.6%
0.200000003	10029	5.6%
0.180000007	10029	5.6%
0.170000002	10029	5.6%
0.159999996	10029	5.6%
0.150000006	10029	5.6%
0.129999995	10029	5.6%
0.119999997	10029	5.6%
0.100000001	10029	5.6%
0.090000004	10029	5.6%

order_item_id
Real number (ℝ)

HIGH CORRELATION UNIFORM UNIQUE

Distinct	180519
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	90260

Minimum	1
Maximum	180519
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1
5-th percentile	9026.9
Q1	45130.5
median	90260
Q3	135389.5
95-th percentile	171493.1
Maximum	180519
Range	180518
Interquartile range (IQR)	90259

Descriptive statistics

Standard deviation	52111.491
Coefficient of variation (CV)	0.57734867
Kurtosis	-1.2
Mean	90260
Median Absolute Deviation (MAD)	45130
Skewness	8.4554661 × 10^-18
Sum	1.6293645 × 10¹⁰
Variance	2.7156075 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
180517	1	< 0.1%
42681	1	< 0.1%
28953	1	< 0.1%
39851	1	< 0.1%
173601	1	< 0.1%
46791	1	< 0.1%
166889	1	< 0.1%
31184	1	< 0.1%
29248	1	< 0.1%
161714	1	< 0.1%
Other values (180509)	180509	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
180519	1	< 0.1%
180518	1	< 0.1%
180517	1	< 0.1%
180516	1	< 0.1%
180515	1	< 0.1%
180514	1	< 0.1%
180513	1	< 0.1%
180512	1	< 0.1%
180511	1	< 0.1%
180510	1	< 0.1%

order_item_profit_ratio
Real number (ℝ)

Distinct	162
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.12064664

Minimum	-2.75
Maximum	0.5
Zeros	1177
Zeros (%)	0.7%
Negative	33784
Negative (%)	18.7%
Memory size	1.4 MiB

Quantile statistics

Minimum	-2.75
5-th percentile	-0.76999998
Q1	0.079999998
median	0.27000001
Q3	0.36000001
95-th percentile	0.47999999
Maximum	0.5
Range	3.25
Interquartile range (IQR)	0.28000002

Descriptive statistics

Standard deviation	0.4667956
Coefficient of variation (CV)	3.8691142
Kurtosis	10.157225
Mean	0.12064664
Median Absolute Deviation (MAD)	0.16999999
Skewness	-2.8935313
Sum	21779.01
Variance	0.21789814
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.479999989	9197	5.1%
0.349999994	7997	4.4%
0.25999999	6577	3.6%
0.340000004	6507	3.6%
0.469999999	6378	3.5%
0.360000014	6108	3.4%
0.330000013	5789	3.2%
0.49000001	5688	3.2%
0.289999992	5478	3.0%
0.280000001	5403	3.0%
Other values (152)	115397	63.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2.75	72	< 0.1%
-2.700000048	252	0.1%
-2.650000095	90	< 0.1%
-2.599999905	181	0.1%
-2.549999952	234	0.1%
-2.5	180	0.1%
-2.450000048	18	< 0.1%
-2.349999905	36	< 0.1%
-2.299999952	18	< 0.1%
-2.25	36	< 0.1%

Value	Count	Frequency (%)
0.5	2529	1.4%
0.49000001	5688	3.2%
0.479999989	9197	5.1%
0.469999999	6378	3.5%
0.460000008	4822	2.7%
0.449999988	3973	2.2%
0.439999998	1390	0.8%
0.430000007	1085	0.6%
0.419999987	1245	0.7%
0.409999996	995	0.6%

order_item_quantity
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

1	99134
5	20385
3	20350
4	20335
2	20315

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	180519
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Most occurring characters

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	180519	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	180519	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	180519	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

sales
Real number (ℝ)

Distinct	193
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	203.7721

Minimum	9.9899998
Maximum	1999.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	9.9899998
5-th percentile	49.98
Q1	119.98
median	199.92
Q3	299.95001
95-th percentile	399.98001
Maximum	1999.99
Range	1990
Interquartile range (IQR)	179.97001

Descriptive statistics

Standard deviation	132.27308
Coefficient of variation (CV)	0.64912262
Kurtosis	23.936561
Mean	203.7721
Median Absolute Deviation (MAD)	79.939995
Skewness	2.884249
Sum	36784735
Variance	17496.167
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
129.9900055	22372	12.4%
399.980011	17325	9.6%
199.9900055	15622	8.7%
299.980011	13729	7.6%
179.9700012	5016	2.8%
299.9500122	4988	2.8%
119.9800034	4968	2.8%
239.9600067	4955	2.7%
59.99000168	4893	2.7%
50	4432	2.5%
Other values (183)	82219	45.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.989999771	56	< 0.1%
11.28999996	271	0.2%
11.53999996	529	0.3%
14.98999977	124	0.1%
15.98999977	118	0.1%
17.98999977	62	< 0.1%
19.97999954	54	< 0.1%
19.98999977	176	0.1%
21.98999977	51	< 0.1%
22	64	< 0.1%

Value	Count	Frequency (%)
1999.98999	15	< 0.1%
1500	442	0.2%
999.9899902	10	< 0.1%
599.9899902	21	< 0.1%
532.5800171	484	0.3%
500	15	< 0.1%
499.9500122	2510	1.4%
499.75	12	< 0.1%
495	14	< 0.1%
474.9500122	15	< 0.1%

order_region
Categorical

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Central America	28341
Western Europe	27109
South America	14935
Oceania	10148
Northern Europe	9792
Other values (18)	90194

Length

Max length	15
Median length	14
Mean length	12.634304
Min length	6

Characters and Unicode

Total characters	2280732
Distinct characters	26
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Southeast Asia
2nd row	South Asia
3rd row	South Asia
4th row	Oceania
5th row	Oceania

Common Values

Value	Count	Frequency (%)
Central America	28341	15.7%
Western Europe	27109	15.0%
South America	14935	8.3%
Oceania	10148	5.6%
Northern Europe	9792	5.4%
Southeast Asia	9539	5.3%
Southern Europe	9431	5.2%
Caribbean	8318	4.6%
West of USA	7993	4.4%
South Asia	7731	4.3%
Other values (13)	47182	26.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
europe	50252	13.9%
america	43276	12.0%
asia	31112	8.6%
central	30571	8.5%
western	27109	7.5%
south	26711	7.4%
of	18953	5.3%
usa	18953	5.3%
west	17698	4.9%
africa	11614	3.2%
Other values (11)	84317	23.4%

Most occurring characters

Value	Count	Frequency (%)
e	267374	11.7%
r	221631	9.7%
	202017	8.9%
a	185888	8.2%
t	170633	7.5%
o	129067	5.7%
n	114572	5.0%
s	105425	4.6%
A	104955	4.6%
i	104468	4.6%
Other values (16)	674702	29.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1693309	74.2%
Uppercase Letter	385406	16.9%
Space Separator	202017	8.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	267374	15.8%
r	221631	13.1%
a	185888	11.0%
t	170633	10.1%
o	129067	7.6%
n	114572	6.8%
s	105425	6.2%
i	104468	6.2%
u	97090	5.7%
c	65038	3.8%
Other values (7)	232123	13.7%

Uppercase Letter

Value	Count	Frequency (%)
A	104955	27.2%
S	71678	18.6%
E	70219	18.2%
C	45735	11.9%
W	44807	11.6%
U	24840	6.4%
N	13024	3.4%
O	10148	2.6%

Space Separator

Value	Count	Frequency (%)
	202017	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2078715	91.1%
Common	202017	8.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	267374	12.9%
r	221631	10.7%
a	185888	8.9%
t	170633	8.2%
o	129067	6.2%
n	114572	5.5%
s	105425	5.1%
A	104955	5.0%
i	104468	5.0%
u	97090	4.7%
Other values (15)	577612	27.8%

Common

Value	Count	Frequency (%)
	202017	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2280732	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	267374	11.7%
r	221631	9.7%
	202017	8.9%
a	185888	8.2%
t	170633	7.5%
o	129067	5.7%
n	114572	5.0%
s	105425	4.6%
A	104955	4.6%
i	104468	4.6%
Other values (16)	674702	29.6%

order_state
Categorical

Distinct	1089
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Inglaterra	6722
California	4966
Isla de Francia	4580
Renania del Norte-Westfalia	3303
San Salvador	3055
Other values (1084)	157893

Length

Max length	36
Median length	31
Mean length	10.872617
Min length	3

Characters and Unicode

Total characters	1962714
Distinct characters	83
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16 ?
Unique (%)	< 0.1%

Sample

1st row	Java Occidental
2nd row	Rajastán
3rd row	Rajastán
4th row	Queensland
5th row	Queensland

Common Values

Value	Count	Frequency (%)
Inglaterra	6722	3.7%
California	4966	2.8%
Isla de Francia	4580	2.5%
Renania del Norte-Westfalia	3303	1.8%
San Salvador	3055	1.7%
Nueva York	2753	1.5%
Distrito Federal	2559	1.4%
Texas	2446	1.4%
Nueva Gales del Sur	2370	1.3%
Santo Domingo	2211	1.2%
Other values (1079)	145554	80.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	9121	3.5%
del	8417	3.2%
inglaterra	6722	2.5%
california	5580	2.1%
nueva	5473	2.1%
isla	4667	1.8%
francia	4580	1.7%
san	3965	1.5%
sur	3354	1.3%
norte-westfalia	3303	1.3%
Other values (1171)	208627	79.1%

Most occurring characters

Value	Count	Frequency (%)
a	310562	15.8%
n	142494	7.3%
i	131317	6.7%
e	131085	6.7%
r	117395	6.0%
o	114621	5.8%
l	103549	5.3%
	83290	4.2%
t	80118	4.1%
s	75596	3.9%
Other values (73)	672687	34.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1584761	80.7%
Uppercase Letter	268229	13.7%
Space Separator	83290	4.2%
Dash Punctuation	24466	1.2%
Open Punctuation	664	< 0.1%
Close Punctuation	664	< 0.1%
Other Punctuation	627	< 0.1%
Control	13	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	310562	19.6%
n	142494	9.0%
i	131317	8.3%
e	131085	8.3%
r	117395	7.4%
o	114621	7.2%
l	103549	6.5%
t	80118	5.1%
s	75596	4.8%
u	62262	3.9%
Other values (35)	315762	19.9%

Uppercase Letter

Value	Count	Frequency (%)
C	30372	11.3%
S	27262	10.2%
A	20489	7.6%
P	18540	6.9%
M	16660	6.2%
N	16027	6.0%
I	14188	5.3%
B	12615	4.7%
G	12427	4.6%
L	11348	4.2%
Other values (20)	88301	32.9%

Other Punctuation

Value	Count	Frequency (%)
?	503	80.2%
'	124	19.8%

Control

Value	Count	Frequency (%)
	8	61.5%
	5	38.5%

Space Separator

Value	Count	Frequency (%)
	83290	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	24466	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	664	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	664	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1852990	94.4%
Common	109724	5.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	310562	16.8%
n	142494	7.7%
i	131317	7.1%
e	131085	7.1%
r	117395	6.3%
o	114621	6.2%
l	103549	5.6%
t	80118	4.3%
s	75596	4.1%
u	62262	3.4%
Other values (65)	583991	31.5%

Common

Value	Count	Frequency (%)
	83290	75.9%
-	24466	22.3%
(	664	0.6%
)	664	0.6%
?	503	0.5%
'	124	0.1%
	8	< 0.1%
	5	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1925211	98.1%
None	37503	1.9%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	310562	16.1%
n	142494	7.4%
i	131317	6.8%
e	131085	6.8%
r	117395	6.1%
o	114621	6.0%
l	103549	5.4%
	83290	4.3%
t	80118	4.2%
s	75596	3.9%
Other values (48)	635184	33.0%

None

Value	Count	Frequency (%)
í	11965	31.9%
á	10023	26.7%
ó	4698	12.5%
é	3332	8.9%
ñ	3173	8.5%
ã	2031	5.4%
ú	918	2.4%
ü	380	1.0%
à	171	0.5%
ô	168	0.4%
Other values (15)	644	1.7%

order_status
Categorical

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

COMPLETE	59491
PENDING_PAYMENT	39832
PROCESSING	21902
PENDING	20227
CLOSED	19616
Other values (4)	19451

Length

Max length	15
Median length	14
Mean length	9.6239676
Min length	6

Characters and Unicode

Total characters	1737309
Distinct characters	21
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	COMPLETE
2nd row	PENDING
3rd row	CLOSED
4th row	COMPLETE
5th row	PENDING_PAYMENT

Common Values

Value	Count	Frequency (%)
COMPLETE	59491	33.0%
PENDING_PAYMENT	39832	22.1%
PROCESSING	21902	12.1%
PENDING	20227	11.2%
CLOSED	19616	10.9%
ON_HOLD	9804	5.4%
SUSPECTED_FRAUD	4062	2.3%
CANCELED	3692	2.0%
PAYMENT_REVIEW	1893	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
complete	59491	33.0%
pending_payment	39832	22.1%
processing	21902	12.1%
pending	20227	11.2%
closed	19616	10.9%
on_hold	9804	5.4%
suspected_fraud	4062	2.3%
canceled	3692	2.0%
payment_review	1893	1.0%

Most occurring characters

Value	Count	Frequency (%)
E	281578	16.2%
N	197241	11.4%
P	187239	10.8%
O	120617	6.9%
C	112455	6.5%
T	105278	6.1%
D	101295	5.8%
M	101216	5.8%
L	92603	5.3%
I	83854	4.8%
Other values (11)	353933	20.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1681718	96.8%
Connector Punctuation	55591	3.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	281578	16.7%
N	197241	11.7%
P	187239	11.1%
O	120617	7.2%
C	112455	6.7%
T	105278	6.3%
D	101295	6.0%
M	101216	6.0%
L	92603	5.5%
I	83854	5.0%
Other values (10)	298342	17.7%

Connector Punctuation

Value	Count	Frequency (%)
_	55591	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1681718	96.8%
Common	55591	3.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	281578	16.7%
N	197241	11.7%
P	187239	11.1%
O	120617	7.2%
C	112455	6.7%
T	105278	6.3%
D	101295	6.0%
M	101216	6.0%
L	92603	5.5%
I	83854	5.0%
Other values (10)	298342	17.7%

Common

Value	Count	Frequency (%)
_	55591	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1737309	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	281578	16.2%
N	197241	11.4%
P	187239	10.8%
O	120617	6.9%
C	112455	6.5%
T	105278	6.1%
D	101295	5.8%
M	101216	5.8%
L	92603	5.3%
I	83854	4.8%
Other values (11)	353933	20.4%

product_id_card
Real number (ℝ)

Distinct	118
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	692.50976

Minimum	19
Maximum	1363
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	19
5-th percentile	191
Q1	403
median	627
Q3	1004
95-th percentile	1073
Maximum	1363
Range	1344
Interquartile range (IQR)	601

Descriptive statistics

Standard deviation	336.44681
Coefficient of variation (CV)	0.48583692
Kurtosis	-1.2674939
Mean	692.50976
Median Absolute Deviation (MAD)	330
Skewness	0.13825461
Sum	1.2501117 × 10⁸
Variance	113196.45
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
365	24515	13.6%
403	22246	12.3%
502	21035	11.7%
1014	19298	10.7%
1004	17325	9.6%
1073	15500	8.6%
957	13729	7.6%
191	12169	6.7%
627	10617	5.9%
1362	838	0.5%
Other values (108)	23247	12.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19	64	< 0.1%
24	74	< 0.1%
35	65	< 0.1%
37	262	0.1%
44	305	0.2%
58	29	< 0.1%
60	10	< 0.1%
61	28	< 0.1%
78	63	< 0.1%
93	280	0.2%

Value	Count	Frequency (%)
1363	650	0.4%
1362	838	0.5%
1361	529	0.3%
1360	357	0.2%
1359	492	0.3%
1358	434	0.2%
1357	208	0.1%
1356	362	0.2%
1355	484	0.3%
1354	483	0.3%

product_name
Categorical

Distinct	118
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Perfect Fitness Perfect Rip Deck	24515
Nike Men's CJ Elite 2 TD Football Cleat	22246
Nike Men's Dri-FIT Victory Golf Polo	21035
O'Brien Men's Neoprene Life Vest	19298
Field & Stream Sportsman 16 Gun Fire Safe	17325
Other values (113)	76100

Length

Max length	45
Median length	43
Mean length	35.120004
Min length	5

Characters and Unicode

Total characters	6339828
Distinct characters	66
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Smart watch
2nd row	Smart watch
3rd row	Smart watch
4th row	Smart watch
5th row	Smart watch

Common Values

Value	Count	Frequency (%)
Perfect Fitness Perfect Rip Deck	24515	13.6%
Nike Men's CJ Elite 2 TD Football Cleat	22246	12.3%
Nike Men's Dri-FIT Victory Golf Polo	21035	11.7%
O'Brien Men's Neoprene Life Vest	19298	10.7%
Field & Stream Sportsman 16 Gun Fire Safe	17325	9.6%
Pelican Sunstream 100 Kayak	15500	8.6%
Diamondback Women's Serene Classic Comfort Bi	13729	7.6%
Nike Men's Free 5.0+ Running Shoe	12169	6.7%
Under Armour Girls' Toddler Spine Surge Runni	10617	5.9%
Fighting video games	838	0.5%
Other values (108)	23247	12.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
men's	77602	7.3%
nike	57309	5.4%
perfect	49030	4.6%
golf	26281	2.5%
rip	24515	2.3%
deck	24515	2.3%
fitness	24515	2.3%
cleat	22813	2.1%
2	22574	2.1%
elite	22309	2.1%
Other values (351)	715106	67.0%

Most occurring characters

Value	Count	Frequency (%)
	887824	14.0%
e	733504	11.6%
i	378177	6.0%
n	350567	5.5%
r	340664	5.4%
o	293733	4.6%
t	274503	4.3%
s	263028	4.1%
l	230952	3.6%
a	230847	3.6%
Other values (56)	2356029	37.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4011603	63.3%
Uppercase Letter	1110988	17.5%
Space Separator	887824	14.0%
Other Punctuation	157902	2.5%
Decimal Number	136270	2.1%
Dash Punctuation	23040	0.4%
Math Symbol	12201	0.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	126137	11.4%
F	119900	10.8%
P	92713	8.3%
D	85981	7.7%
M	81289	7.3%
N	79408	7.1%
C	77993	7.0%
T	64000	5.8%
G	62759	5.6%
R	50142	4.5%
Other values (15)	270666	24.4%

Lowercase Letter

Value	Count	Frequency (%)
e	733504	18.3%
i	378177	9.4%
n	350567	8.7%
r	340664	8.5%
o	293733	7.3%
t	274503	6.8%
s	263028	6.6%
l	230952	5.8%
a	230847	5.8%
c	150579	3.8%
Other values (14)	765049	19.1%

Decimal Number

Value	Count	Frequency (%)
0	44762	32.8%
1	34956	25.7%
2	23239	17.1%
6	18574	13.6%
5	12729	9.3%
4	756	0.6%
3	643	0.5%
8	555	0.4%
9	45	< 0.1%
7	11	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
'	127155	80.5%
&	17387	11.0%
.	12979	8.2%
/	381	0.2%

Space Separator

Value	Count	Frequency (%)
	887824	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	23040	100.0%

Math Symbol

Value	Count	Frequency (%)
+	12201	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5122591	80.8%
Common	1217237	19.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	733504	14.3%
i	378177	7.4%
n	350567	6.8%
r	340664	6.7%
o	293733	5.7%
t	274503	5.4%
s	263028	5.1%
l	230952	4.5%
a	230847	4.5%
c	150579	2.9%
Other values (39)	1876037	36.6%

Common

Value	Count	Frequency (%)
	887824	72.9%
'	127155	10.4%
0	44762	3.7%
1	34956	2.9%
2	23239	1.9%
-	23040	1.9%
6	18574	1.5%
&	17387	1.4%
.	12979	1.1%
5	12729	1.0%
Other values (7)	14592	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6339828	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	887824	14.0%
e	733504	11.6%
i	378177	6.0%
n	350567	5.5%
r	340664	5.4%
o	293733	4.6%
t	274503	4.3%
s	263028	4.1%
l	230952	3.6%
a	230847	3.6%
Other values (56)	2356029	37.2%

product_price
Real number (ℝ)

Distinct	75
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	141.23255

Minimum	9.9899998
Maximum	1999.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	9.9899998
5-th percentile	31.99
Q1	50
median	59.990002
Q3	199.99001
95-th percentile	399.98001
Maximum	1999.99
Range	1990
Interquartile range (IQR)	149.99001

Descriptive statistics

Standard deviation	139.73249
Coefficient of variation (CV)	0.98937881
Kurtosis	23.312997
Mean	141.23255
Median Absolute Deviation (MAD)	39.999996
Skewness	3.1910196
Sum	25495159
Variance	19525.169
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.99000168	24820	13.7%
129.9900055	22372	12.4%
50	21035	11.7%
49.97999954	19298	10.7%
399.980011	17325	9.6%
199.9900055	15622	8.7%
299.980011	13729	7.6%
99.98999786	12433	6.9%
39.99000168	11201	6.2%
24.98999977	2339	1.3%
Other values (65)	20345	11.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.989999771	285	0.2%
11.28999996	271	0.2%
11.53999996	529	0.3%
14.98999977	593	0.3%
15.98999977	602	0.3%
17.98999977	298	0.2%
19.98999977	887	0.5%
21.98999977	295	0.2%
22	308	0.2%
24.98999977	2339	1.3%

Value	Count	Frequency (%)
1999.98999	15	< 0.1%
1500	442	0.2%
999.9899902	10	< 0.1%
599.9899902	21	< 0.1%
532.5800171	484	0.3%
461.480011	484	0.3%
452.0400085	592	0.3%
399.9899902	67	< 0.1%
399.980011	17325	9.6%
357.1000061	652	0.4%

product_status
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

0	180519

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	180519
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	180519	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	180519	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	180519	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	180519	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	180519	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	180519	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	180519	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	180519	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	180519	100.0%

shipping_date
Categorical

HIGH CARDINALITY UNIFORM

Distinct	63701
Distinct (%)	35.3%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

1/5/2016 5:58	10
7/16/2015 10:14	10
4/17/2015 22:16	10
5/27/2015 6:48	10
5/9/2015 18:02	10
Other values (63696)	180469

Length

Max length	16
Median length	15
Mean length	14.501942
Min length	13

Characters and Unicode

Total characters	2617876
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18557 ?
Unique (%)	10.3%

Sample

1st row	2/3/2018 22:56
2nd row	1/18/2018 12:27
3rd row	1/17/2018 12:06
4th row	1/16/2018 11:45
5th row	1/15/2018 11:24

Common Values

Value	Count	Frequency (%)
1/5/2016 5:58	10	< 0.1%
7/16/2015 10:14	10	< 0.1%
4/17/2015 22:16	10	< 0.1%
5/27/2015 6:48	10	< 0.1%
5/9/2015 18:02	10	< 0.1%
3/13/2016 5:10	10	< 0.1%
12/16/2015 2:50	10	< 0.1%
6/5/2017 12:25	10	< 0.1%
5/8/2015 2:06	10	< 0.1%
3/31/2017 19:52	10	< 0.1%
Other values (63691)	180419	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
9/27/2017	266	0.1%
5/4/2017	244	0.1%
7/9/2017	242	0.1%
7/16/2016	240	0.1%
8/22/2016	239	0.1%
1/15/2017	239	0.1%
2/21/2016	237	0.1%
9/20/2016	232	0.1%
11/4/2015	231	0.1%
5/12/2017	228	0.1%
Other values (2561)	358640	99.3%

Most occurring characters

Value	Count	Frequency (%)
1	475279	18.2%
2	385619	14.7%
/	361038	13.8%
0	282104	10.8%
	180519	6.9%
:	180519	6.9%
5	159085	6.1%
6	128246	4.9%
7	120339	4.6%
3	113285	4.3%
Other values (3)	231843	8.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1895800	72.4%
Other Punctuation	541557	20.7%
Space Separator	180519	6.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	475279	25.1%
2	385619	20.3%
0	282104	14.9%
5	159085	8.4%
6	128246	6.8%
7	120339	6.3%
3	113285	6.0%
4	96927	5.1%
8	68656	3.6%
9	66260	3.5%

Other Punctuation

Value	Count	Frequency (%)
/	361038	66.7%
:	180519	33.3%

Space Separator

Value	Count	Frequency (%)
	180519	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2617876	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	475279	18.2%
2	385619	14.7%
/	361038	13.8%
0	282104	10.8%
	180519	6.9%
:	180519	6.9%
5	159085	6.1%
6	128246	4.9%
7	120339	4.6%
3	113285	4.3%
Other values (3)	231843	8.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2617876	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	475279	18.2%
2	385619	14.7%
/	361038	13.8%
0	282104	10.8%
	180519	6.9%
:	180519	6.9%
5	159085	6.1%
6	128246	4.9%
7	120339	4.6%
3	113285	4.3%
Other values (3)	231843	8.9%

shipping_mode
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Standard Class	107752
Second Class	35216
First Class	27814
Same Day	9737

Length

Max length	14
Median length	14
Mean length	12.823969
Min length	8

Characters and Unicode

Total characters	2314970
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Standard Class
2nd row	Standard Class
3rd row	Standard Class
4th row	Standard Class
5th row	Standard Class

Common Values

Value	Count	Frequency (%)
Standard Class	107752	59.7%
Second Class	35216	19.5%
First Class	27814	15.4%
Same Day	9737	5.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
class	170782	47.3%
standard	107752	29.8%
second	35216	9.8%
first	27814	7.7%
same	9737	2.7%
day	9737	2.7%

Most occurring characters

Value	Count	Frequency (%)
a	405760	17.5%
s	369378	16.0%
d	250720	10.8%
	180519	7.8%
l	170782	7.4%
C	170782	7.4%
S	152705	6.6%
n	142968	6.2%
r	135566	5.9%
t	135566	5.9%
Other values (8)	200224	8.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1773413	76.6%
Uppercase Letter	361038	15.6%
Space Separator	180519	7.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	405760	22.9%
s	369378	20.8%
d	250720	14.1%
l	170782	9.6%
n	142968	8.1%
r	135566	7.6%
t	135566	7.6%
e	44953	2.5%
c	35216	2.0%
o	35216	2.0%
Other values (3)	47288	2.7%

Uppercase Letter

Value	Count	Frequency (%)
C	170782	47.3%
S	152705	42.3%
F	27814	7.7%
D	9737	2.7%

Space Separator

Value	Count	Frequency (%)
	180519	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2134451	92.2%
Common	180519	7.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	405760	19.0%
s	369378	17.3%
d	250720	11.7%
l	170782	8.0%
C	170782	8.0%
S	152705	7.2%
n	142968	6.7%
r	135566	6.4%
t	135566	6.4%
e	44953	2.1%
Other values (7)	155271	7.3%

Common

Value	Count	Frequency (%)
	180519	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2314970	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	405760	17.5%
s	369378	16.0%
d	250720	10.8%
	180519	7.8%
l	170782	7.4%
C	170782	7.4%
S	152705	6.6%
n	142968	6.2%
r	135566	5.9%
t	135566	5.9%
Other values (8)	200224	8.6%

Auto

Heatmap
Table

	shipping_days_real	profit_per_order	sales_per_customer	category_id	customer_id	department_id	order_id	order_item_discount	order_item_discount_rate	order_item_id	order_item_profit_ratio	sales	product_id_card	product_price	type	shipping_days_scheduled	delivery_status	late_delivery_risk	category_name	customer_country	customer_segment	customer_state	department_name	market	order_item_quantity	order_region	order_status	shipping_mode
shipping_days_real	1.000	-0.003	-0.000	-0.002	0.004	-0.002	-0.002	0.001	0.001	-0.002	-0.003	-0.000	-0.002	-0.000	0.010	0.681	0.561	0.631	0.006	0.011	0.009	0.027	0.006	0.008	0.000	0.022	0.008	0.681
profit_per_order	-0.003	1.000	0.441	0.061	0.003	0.085	0.017	0.196	-0.054	0.017	0.808	0.436	0.060	0.287	0.003	0.002	0.000	0.000	0.232	0.000	0.000	0.011	0.127	0.021	0.034	0.014	0.000	0.002
sales_per_customer	-0.000	0.441	1.000	0.162	0.013	0.224	0.041	0.420	-0.133	0.041	-0.000	0.986	0.160	0.639	0.005	0.004	0.005	0.000	0.480	0.000	0.006	0.000	0.241	0.036	0.212	0.026	0.006	0.004
category_id	-0.002	0.061	0.162	1.000	0.133	0.908	0.135	0.073	0.000	0.135	-0.002	0.178	0.998	0.195	0.001	0.009	0.000	0.000	0.973	0.000	0.008	0.008	0.683	0.158	0.232	0.118	0.001	0.009
customer_id	0.004	0.003	0.013	0.133	1.000	0.061	0.133	0.003	0.002	0.133	-0.000	0.014	0.133	0.039	0.005	0.009	0.006	0.004	0.512	0.015	0.031	0.050	0.336	0.179	0.099	0.134	0.008	0.009
department_id	-0.002	0.085	0.224	0.908	0.061	1.000	0.063	0.102	0.000	0.063	-0.003	0.241	0.905	0.202	0.000	0.010	0.001	0.000	0.993	0.000	0.006	0.010	1.000	0.119	0.240	0.089	0.001	0.010
order_id	-0.002	0.017	0.041	0.135	0.133	0.063	1.000	0.019	0.001	1.000	0.001	0.044	0.131	0.082	0.015	0.010	0.009	0.006	0.337	0.012	0.006	0.026	0.242	0.753	0.098	0.551	0.012	0.010
order_item_discount	0.001	0.196	0.420	0.073	0.003	0.102	0.019	1.000	0.795	0.019	-0.002	0.534	0.072	0.356	0.000	0.000	0.000	0.000	0.302	0.001	0.002	0.005	0.162	0.024	0.082	0.018	0.000	0.000
order_item_discount_rate	0.001	-0.054	-0.133	0.000	0.002	0.000	0.001	0.795	1.000	0.001	-0.002	0.000	0.001	0.000	0.000	0.000	0.004	0.006	0.000	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.002	0.000
order_item_id	-0.002	0.017	0.041	0.135	0.133	0.063	1.000	0.019	0.001	1.000	0.001	0.044	0.131	0.082	0.015	0.010	0.008	0.008	0.232	0.011	0.007	0.025	0.166	0.714	0.076	0.532	0.011	0.010
order_item_profit_ratio	-0.003	0.808	-0.000	-0.002	-0.000	-0.003	0.001	-0.002	-0.002	0.001	1.000	-0.001	-0.002	0.000	0.000	0.000	0.000	0.000	0.002	0.000	0.000	0.001	0.000	0.005	0.000	0.000	0.000	0.000
sales	-0.000	0.436	0.986	0.178	0.014	0.241	0.044	0.534	0.000	0.044	-0.001	1.000	0.176	0.667	0.005	0.006	0.000	0.002	0.685	0.000	0.004	0.000	0.343	0.042	0.235	0.042	0.004	0.006
product_id_card	-0.002	0.060	0.160	0.998	0.133	0.905	0.131	0.072	0.001	0.131	-0.002	0.176	1.000	0.192	0.000	0.000	0.000	0.000	0.984	0.000	0.000	0.008	0.784	0.129	0.242	0.105	0.000	0.000
product_price	-0.000	0.287	0.639	0.195	0.039	0.202	0.082	0.356	0.000	0.082	0.000	0.667	0.192	1.000	0.005	0.008	0.000	0.004	0.807	0.000	0.002	0.000	0.394	0.059	0.229	0.060	0.003	0.008
type	0.010	0.003	0.005	0.001	0.005	0.000	0.015	0.000	0.000	0.015	0.000	0.005	0.000	0.005	1.000	0.006	0.198	0.078	0.000	0.006	0.005	0.023	0.000	0.011	0.000	0.019	1.000	0.006
shipping_days_scheduled	0.681	0.002	0.004	0.009	0.009	0.010	0.010	0.000	0.000	0.010	0.000	0.006	0.000	0.008	0.006	1.000	0.321	0.457	0.018	0.009	0.008	0.027	0.010	0.007	0.002	0.023	0.009	1.000
delivery_status	0.561	0.000	0.005	0.000	0.006	0.001	0.009	0.000	0.004	0.008	0.000	0.000	0.000	0.000	0.198	0.321	1.000	1.000	0.000	0.003	0.005	0.024	0.000	0.006	0.000	0.018	0.577	0.321
late_delivery_risk	0.631	0.000	0.000	0.000	0.004	0.000	0.006	0.000	0.006	0.008	0.000	0.002	0.000	0.004	0.078	0.457	1.000	1.000	0.000	0.000	0.000	0.018	0.000	0.005	0.000	0.017	0.234	0.457
category_name	0.006	0.232	0.480	0.973	0.512	0.993	0.337	0.302	0.000	0.232	0.002	0.685	0.984	0.807	0.000	0.018	0.000	0.000	1.000	0.000	0.015	0.008	0.994	0.176	0.394	0.084	0.002	0.018
customer_country	0.011	0.000	0.000	0.000	0.015	0.000	0.012	0.001	0.003	0.011	0.000	0.000	0.000	0.000	0.006	0.009	0.003	0.000	0.000	1.000	0.015	1.000	0.000	0.015	0.000	0.020	0.009	0.009
customer_segment	0.009	0.000	0.006	0.008	0.031	0.006	0.006	0.002	0.000	0.007	0.000	0.004	0.000	0.002	0.005	0.008	0.005	0.000	0.015	0.015	1.000	0.061	0.006	0.002	0.004	0.017	0.011	0.008
customer_state	0.027	0.011	0.000	0.008	0.050	0.010	0.026	0.005	0.000	0.025	0.001	0.000	0.008	0.000	0.023	0.027	0.024	0.018	0.008	1.000	0.061	1.000	0.009	0.030	0.000	0.026	0.022	0.027
department_name	0.006	0.127	0.241	0.683	0.336	1.000	0.242	0.162	0.000	0.166	0.000	0.343	0.784	0.394	0.000	0.010	0.000	0.000	0.994	0.000	0.006	0.009	1.000	0.120	0.241	0.085	0.000	0.010
market	0.008	0.021	0.036	0.158	0.179	0.119	0.753	0.024	0.000	0.714	0.005	0.042	0.129	0.059	0.011	0.007	0.006	0.005	0.176	0.015	0.002	0.030	0.120	1.000	0.027	1.000	0.011	0.007
order_item_quantity	0.000	0.034	0.212	0.232	0.099	0.240	0.098	0.082	0.000	0.076	0.000	0.235	0.242	0.229	0.000	0.002	0.000	0.000	0.394	0.000	0.004	0.000	0.241	0.027	1.000	0.031	0.000	0.002
order_region	0.022	0.014	0.026	0.118	0.134	0.089	0.551	0.018	0.000	0.532	0.000	0.042	0.105	0.060	0.019	0.023	0.018	0.017	0.084	0.020	0.017	0.026	0.085	1.000	0.031	1.000	0.017	0.023
order_status	0.008	0.000	0.006	0.001	0.008	0.001	0.012	0.000	0.002	0.011	0.000	0.004	0.000	0.003	1.000	0.009	0.577	0.234	0.002	0.009	0.011	0.022	0.000	0.011	0.000	0.017	1.000	0.009
shipping_mode	0.681	0.002	0.004	0.009	0.009	0.010	0.010	0.000	0.000	0.010	0.000	0.006	0.000	0.008	0.006	1.000	0.321	0.457	0.018	0.009	0.008	0.027	0.010	0.007	0.002	0.023	0.009	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	type	shipping_days_real	shipping_days_scheduled	profit_per_order	sales_per_customer	delivery_status	late_delivery_risk	category_id	category_name	customer_city	customer_country	customer_id	customer_segment	customer_state	department_id	department_name	market	order_city	order_country	order_date	order_id	order_item_discount	order_item_discount_rate	order_item_id	order_item_profit_ratio	order_item_quantity	sales	order_region	order_state	order_status	product_id_card	product_name	product_price	shipping_date	shipping_mode
0	DEBIT	3	4	91.250000	314.640015	Advance shipping	0	73	Sporting Goods	Caguas	Puerto Rico	20755	Consumer	PR	2	Fitness	Pacific Asia	Bekasi	Indonesia	1/31/2018 22:56	77202	13.110000	0.04	180517	0.29	1	327.75	Southeast Asia	Java Occidental	COMPLETE	1360	Smart watch	327.75	2/3/2018 22:56	Standard Class
1	TRANSFER	5	4	-249.089996	311.359985	Late delivery	1	73	Sporting Goods	Caguas	Puerto Rico	19492	Consumer	PR	2	Fitness	Pacific Asia	Bikaner	India	1/13/2018 12:27	75939	16.389999	0.05	179254	-0.80	1	327.75	South Asia	Rajastán	PENDING	1360	Smart watch	327.75	1/18/2018 12:27	Standard Class
2	CASH	4	4	-247.779999	309.720001	Shipping on time	0	73	Sporting Goods	San Jose	EE. UU.	19491	Consumer	CA	2	Fitness	Pacific Asia	Bikaner	India	1/13/2018 12:06	75938	18.030001	0.06	179253	-0.80	1	327.75	South Asia	Rajastán	CLOSED	1360	Smart watch	327.75	1/17/2018 12:06	Standard Class
3	DEBIT	3	4	22.860001	304.809998	Advance shipping	0	73	Sporting Goods	Los Angeles	EE. UU.	19490	Home Office	CA	2	Fitness	Pacific Asia	Townsville	Australia	1/13/2018 11:45	75937	22.940001	0.07	179252	0.08	1	327.75	Oceania	Queensland	COMPLETE	1360	Smart watch	327.75	1/16/2018 11:45	Standard Class
4	PAYMENT	2	4	134.210007	298.250000	Advance shipping	0	73	Sporting Goods	Caguas	Puerto Rico	19489	Corporate	PR	2	Fitness	Pacific Asia	Townsville	Australia	1/13/2018 11:24	75936	29.500000	0.09	179251	0.45	1	327.75	Oceania	Queensland	PENDING_PAYMENT	1360	Smart watch	327.75	1/15/2018 11:24	Standard Class
5	TRANSFER	6	4	18.580000	294.980011	Shipping canceled	0	73	Sporting Goods	Tonawanda	EE. UU.	19488	Consumer	NY	2	Fitness	Pacific Asia	Toowoomba	Australia	1/13/2018 11:03	75935	32.779999	0.10	179250	0.06	1	327.75	Oceania	Queensland	CANCELED	1360	Smart watch	327.75	1/19/2018 11:03	Standard Class
6	DEBIT	2	1	95.180000	288.420013	Late delivery	1	73	Sporting Goods	Caguas	Puerto Rico	19487	Home Office	PR	2	Fitness	Pacific Asia	Guangzhou	China	1/13/2018 10:42	75934	39.330002	0.12	179249	0.33	1	327.75	Eastern Asia	Guangdong	COMPLETE	1360	Smart watch	327.75	1/15/2018 10:42	First Class
7	TRANSFER	2	1	68.430000	285.140015	Late delivery	1	73	Sporting Goods	Miami	EE. UU.	19486	Corporate	FL	2	Fitness	Pacific Asia	Guangzhou	China	1/13/2018 10:21	75933	42.610001	0.13	179248	0.24	1	327.75	Eastern Asia	Guangdong	PROCESSING	1360	Smart watch	327.75	1/15/2018 10:21	First Class
8	CASH	3	2	133.720001	278.589996	Late delivery	1	73	Sporting Goods	Caguas	Puerto Rico	19485	Corporate	PR	2	Fitness	Pacific Asia	Guangzhou	China	1/13/2018 10:00	75932	49.160000	0.15	179247	0.48	1	327.75	Eastern Asia	Guangdong	CLOSED	1360	Smart watch	327.75	1/16/2018 10:00	Second Class
9	CASH	2	1	132.149994	275.309998	Late delivery	1	73	Sporting Goods	San Ramon	EE. UU.	19484	Corporate	CA	2	Fitness	Pacific Asia	Guangzhou	China	1/13/2018 9:39	75931	52.439999	0.16	179246	0.48	1	327.75	Eastern Asia	Guangdong	CLOSED	1360	Smart watch	327.75	1/15/2018 9:39	First Class

	type	shipping_days_real	shipping_days_scheduled	profit_per_order	sales_per_customer	delivery_status	late_delivery_risk	category_id	category_name	customer_city	customer_country	customer_id	customer_segment	customer_state	department_id	department_name	market	order_city	order_country	order_date	order_id	order_item_discount	order_item_discount_rate	order_item_id	order_item_profit_ratio	order_item_quantity	sales	order_region	order_state	order_status	product_id_card	product_name	product_price	shipping_date	shipping_mode
180509	PAYMENT	3	4	0.000000	335.980011	Advance shipping	0	45	Fishing	Caguas	Puerto Rico	7	Corporate	PR	7	Fan Shop	Pacific Asia	Guangshui	China	1/16/2016 6:49	26052	64.0	0.16	65202	0.00	1	399.980011	Eastern Asia	Hubei	PENDING_PAYMENT	1004	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 6:49	Standard Class
180510	PAYMENT	3	4	165.990005	331.980011	Advance shipping	0	45	Fishing	Caguas	Puerto Rico	7	Corporate	PR	7	Fan Shop	Pacific Asia	Guangshui	China	1/16/2016 6:49	26052	68.0	0.17	65201	0.50	1	399.980011	Eastern Asia	Hubei	PENDING_PAYMENT	1004	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 6:49	Standard Class
180511	DEBIT	2	2	157.429993	327.980011	Shipping on time	0	45	Fishing	Chula Vista	EE. UU.	9314	Consumer	CA	7	Fan Shop	Pacific Asia	Chengdu	China	1/16/2016 6:28	26051	72.0	0.18	65195	0.48	1	399.980011	Eastern Asia	Sichuan	ON_HOLD	1004	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/18/2016 6:28	Second Class
180512	DEBIT	6	4	86.400002	319.980011	Late delivery	1	45	Fishing	Caguas	Puerto Rico	7396	Home Office	PR	7	Fan Shop	Pacific Asia	Chengdu	China	1/16/2016 6:07	26050	80.0	0.20	65194	0.27	1	399.980011	Eastern Asia	Sichuan	COMPLETE	1004	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/22/2016 6:07	Standard Class
180513	PAYMENT	3	4	119.989998	299.989990	Advance shipping	0	45	Fishing	Lancaster	EE. UU.	3080	Home Office	OH	7	Fan Shop	Pacific Asia	Shanghái	China	1/16/2016 5:04	26047	100.0	0.25	65185	0.40	1	399.980011	Eastern Asia	Shanghái	PENDING_PAYMENT	1004	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 5:04	Standard Class
180514	CASH	4	4	40.000000	399.980011	Shipping on time	0	45	Fishing	Brooklyn	EE. UU.	1005	Home Office	NY	7	Fan Shop	Pacific Asia	Shanghái	China	1/16/2016 3:40	26043	0.0	0.00	65177	0.10	1	399.980011	Eastern Asia	Shanghái	CLOSED	1004	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/20/2016 3:40	Standard Class
180515	DEBIT	3	2	-613.770019	395.980011	Late delivery	1	45	Fishing	Bakersfield	EE. UU.	9141	Corporate	CA	7	Fan Shop	Pacific Asia	Hirakata	Japón	1/16/2016 1:34	26037	4.0	0.01	65161	-1.55	1	399.980011	Eastern Asia	Osaka	COMPLETE	1004	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 1:34	Second Class
180516	TRANSFER	5	4	141.110001	391.980011	Late delivery	1	45	Fishing	Bristol	EE. UU.	291	Corporate	CT	7	Fan Shop	Pacific Asia	Adelaide	Australia	1/15/2016 21:00	26024	8.0	0.02	65129	0.36	1	399.980011	Oceania	Australia del Sur	PENDING	1004	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/20/2016 21:00	Standard Class
180517	PAYMENT	3	4	186.229996	387.980011	Advance shipping	0	45	Fishing	Caguas	Puerto Rico	2813	Consumer	PR	7	Fan Shop	Pacific Asia	Adelaide	Australia	1/15/2016 20:18	26022	12.0	0.03	65126	0.48	1	399.980011	Oceania	Australia del Sur	PENDING_PAYMENT	1004	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/18/2016 20:18	Standard Class
180518	PAYMENT	4	4	168.949997	383.980011	Shipping on time	0	45	Fishing	Caguas	Puerto Rico	7547	Consumer	PR	7	Fan Shop	Pacific Asia	Nagercoil	India	1/15/2016 18:54	26018	16.0	0.04	65113	0.44	1	399.980011	South Asia	Tamil Nadu	PENDING_PAYMENT	1004	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 18:54	Standard Class

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter